package com.huangpuweb.api.model;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;

public class LxmElevatorInfoRowMapper implements RowMapper<LxmElevatorInfo>{

	@Override
	public LxmElevatorInfo mapRow(ResultSet rs, int rowNum) throws SQLException {
		LxmElevatorInfo  lj= new LxmElevatorInfo();
		lj.setId(rs.getInt("id"));
		lj.setDevice_code(rs.getString("device_code"));
		lj.setUse_status(rs.getString("use_status"));
		lj.setTest_date(rs.getString("test_date"));
		lj.setTest_result(rs.getString("test_result"));
		lj.setNext_test_date(rs.getString("next_test_date"));
		lj.setNext_selftest_date(rs.getString("next_selftest_date"));
		lj.setPutuse_date(rs.getString("putuse_date"));
		lj.setRegister_type(rs.getString("register_type"));
		lj.setDevice_type(rs.getString("device_type"));
		lj.setPoint_monitor(rs.getString("point_monitor"));
		lj.setUse_unit(rs.getString("use_unit"));
		lj.setLng(rs.getString("lng"));
		lj.setLat(rs.getString("lat"));
		lj.setDevice_use_site(rs.getString("device_use_site"));
		lj.setDevice_use_place(rs.getString("device_use_place"));
		lj.setCheckout_duty_uint(rs.getString("checkout_duty_uint"));
		lj.setSafe_administrator(rs.getString("safe_administrator"));
		lj.setSafe_administrator_phone(rs.getString("safe_administrator_phone"));
		lj.setService_unit_name(rs.getString("service_unit_name"));
		lj.setService_unit_phone(rs.getString("service_unit_phone"));
		lj.setManufacture_date(rs.getString("manufacture_date"));
		lj.setCheckout_type(rs.getString("checkout_type"));
		lj.setDevice_rank(rs.getString("device_rank"));
		lj.setOld_device_status(rs.getString("old_device_status"));
		lj.setManage_unit(rs.getString("manage_unit"));
		lj.setSupervise_person(rs.getString("supervise_person"));
		lj.setYwh_name(rs.getString("ywh_name"));
		lj.setYwh_phone(rs.getString("ywh_phone"));
		lj.setJuwei(rs.getString("juwei"));
		lj.setYwh_person(rs.getString("ywh_person"));
		return lj;
	}

}
